package com.example.demo.mapper;

import com.example.demo.domain.City;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.demo.domain.CitySpotCountAndRating;
import com.example.demo.domain.CitySpotNum;
import com.example.demo.domain.DTO.CityHot;
import com.example.demo.domain.ProvinceCitySpotInfo;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * @author z'z'w
 * @description 针对表【CITY】的数据库操作Mapper
 * @createDate 2023-05-07 14:59:21
 * @Entity com.example.demo.domain.City
 */
@Mapper
public interface CityMapper extends BaseMapper<City> {
    List<City> selectAll();

    List<CityHot> selectCityHot();

    /**
     * 省份城市景点
     *
     * @return
     */
    List<ProvinceCitySpotInfo> selectProvinceCitySpot();

    /**
     * 城市当中有多少个景点
     */
    List<CitySpotNum> selectCitySpotNum();

    /**
     * 城市景点总数平均值
     */
    List<CitySpotCountAndRating> selectCitySpotAvgRating();
}




